SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO

create procedure dbo.DnnProduct_GetVendorClassifications

@VendorId  int

as

select ClassificationId,
       ClassificationName,
       'IsAssociated' = case when exists ( select 1 from dbo.DnnProduct_VendorClassification vc where vc.VendorId = @VendorId and vc.ClassificationId = DnnProduct_Classification.ClassificationId ) then 1 else 0 end
from dbo.DnnProduct_Classification








GO
